Tabela WHStayingTime

Definicja tabeli WHStayingTime

Name

WHStayingTime

Code

WHStayingTime

Comment

 


Lista kolumn tabeli WHStayingTime

Name

Code

FullDT

FullDT

StayingTime

StayingTime

StayingTime7D

StayingTime7D

StayingTime30D

StayingTime30D

StayingTimeThisMonth

StayingTimeThisMonth

StayingTimeThisYear

StayingTimeThisYear

DischargeCount

DischargeCount


Kolumna FullDT tabeli WHStayingTime

Definicja kolumny FullDT tabeli WHStayingTime

Name

FullDT

Code

FullDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna StayingTime tabeli WHStayingTime

Definicja kolumny StayingTime tabeli WHStayingTime

Name

StayingTime

Code

StayingTime

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna StayingTime7D tabeli WHStayingTime

Definicja kolumny StayingTime7D tabeli WHStayingTime

Name

StayingTime7D

Code

StayingTime7D

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna StayingTime30D tabeli WHStayingTime

Definicja kolumny StayingTime30D tabeli WHStayingTime

Name

StayingTime30D

Code

StayingTime30D

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna StayingTimeThisMonth tabeli WHStayingTime

Definicja kolumny StayingTimeThisMonth tabeli WHStayingTime

Name

StayingTimeThisMonth

Code

StayingTimeThisMonth

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna StayingTimeThisYear tabeli WHStayingTime

Definicja kolumny StayingTimeThisYear tabeli WHStayingTime

Name

StayingTimeThisYear

Code

StayingTimeThisYear

Data Type

FLOAT

Mandatory

No

Comment

 


Kolumna DischargeCount tabeli WHStayingTime

Definicja kolumny DischargeCount tabeli WHStayingTime

Name

DischargeCount

Code

DischargeCount

Data Type

NUMBER(10)

Mandatory

No

Comment

Ilosc pobytów na podstawie których zostal policzony sredni czas pobytu


Lista kluczy tabeli WHStayingTime

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WHStayingTime

Definicja klucza Identifier_1 tabeli WHStayingTime

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment